Overview

Dataset statistics

Number of variables27
Number of observations723
Missing cells237
Missing cells (%)1.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory152.6 KiB
Average record size in memory216.2 B

Variable types

NUM13
CAT11
UNSUPPORTED2
URL1

Reproduction

Analysis started2020-11-23 10:12:40.834982
Analysis finished2020-11-23 10:13:53.623056
Duration1 minute and 12.79 seconds
Versionpandas-profiling v2.8.0
Command linepandas_profiling --config_file config.yaml [YOUR_FILE.csv]
Download configurationconfig.yaml

Warnings

director has a high cardinality: 585 distinct values High cardinality
released has a high cardinality: 308 distinct values High cardinality
star has a high cardinality: 437 distinct values High cardinality
writer has a high cardinality: 613 distinct values High cardinality
hashtag has a high cardinality: 722 distinct values High cardinality
name_roten has a high cardinality: 722 distinct values High cardinality
synopsis has a high cardinality: 661 distinct values High cardinality
year is highly correlated with year_releasedHigh correlation
year_released is highly correlated with yearHigh correlation
calificacion1_dec is highly correlated with calificacion1High correlation
calificacion1 is highly correlated with calificacion1_decHigh correlation
calificacion2_dec is highly correlated with calificacion2High correlation
calificacion2 is highly correlated with calificacion2_decHigh correlation
calificacion1 has 58 (8.0%) missing values Missing
calificacion2 has 58 (8.0%) missing values Missing
calificacion1_dec has 58 (8.0%) missing values Missing
calificacion2_dec has 58 (8.0%) missing values Missing
director is uniformly distributed Uniform
star is uniformly distributed Uniform
writer is uniformly distributed Uniform
hashtag is uniformly distributed Uniform
name_roten is uniformly distributed Uniform
gross has unique values Unique
company is an unsupported type, check if it needs cleaning or further analysis Unsupported
name is an unsupported type, check if it needs cleaning or further analysis Unsupported
budget has 124 (17.2%) zeros Zeros
promedio_ganancia has 292 (40.4%) zeros Zeros
calificacion1_dec has 26 (3.6%) zeros Zeros

Variables

budget
Real number (ℝ≥0)

ZEROS

Distinct count141
Unique (%)19.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean40008846.70401107
Minimum0
Maximum250000000
Zeros124
Zeros (%)17.2%
Memory size5.6 KiB

Quantile statistics

Minimum0
5-th percentile0
Q14450000
median20000000
Q350000000
95-th percentile170000000
Maximum250000000
Range250000000
Interquartile range (IQR)45550000

Descriptive statistics

Standard deviation52935707.8
Coefficient of variation (CV)1.323100068
Kurtosis2.813575462
Mean40008846.7
Median Absolute Deviation (MAD)19000000
Skewness1.840083157
Sum2.892639617e+10
Variance2.80218916e+15
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
012417.2%
 
20000000263.6%
 
5000000243.3%
 
40000000233.2%
 
30000000223.0%
 
35000000223.0%
 
15000000202.8%
 
25000000192.6%
 
10000000192.6%
 
50000000162.2%
 
Other values (131)40856.4%
 
ValueCountFrequency (%) 
012417.2%
 
5000020.3%
 
10000020.3%
 
13000010.1%
 
20000010.1%
 
ValueCountFrequency (%) 
25000000030.4%
 
24500000020.3%
 
22500000020.3%
 
21500000020.3%
 
21000000010.1%
 

company
Unsupported

REJECTED
UNSUPPORTED

Missing0
Missing (%)0.0%
Memory size5.8 KiB

country
Categorical

Distinct count3
Unique (%)0.4%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
USA
577
UK
116
France
 
30
ValueCountFrequency (%) 
USA57779.8%
 
UK11616.0%
 
France304.1%
 

Length

Max length6
Median length3
Mean length2.964038728
Min length2

director
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count585
Unique (%)80.9%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Woody Allen
 
4
Denis Villeneuve
 
3
James DeMonaco
 
3
Ridley Scott
 
3
Clint Eastwood
 
3
Other values (580)
707
ValueCountFrequency (%) 
Woody Allen40.6%
 
Denis Villeneuve30.4%
 
James DeMonaco30.4%
 
Ridley Scott30.4%
 
Clint Eastwood30.4%
 
Shawn Levy30.4%
 
Robert Schwentke30.4%
 
Paul Feig30.4%
 
James Wan30.4%
 
Nicholas Stoller30.4%
 
Other values (575)69295.7%
 

Length

Max length27
Median length13
Mean length12.99585062
Min length3

genre
Categorical

Distinct count14
Unique (%)1.9%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Action
175
Comedy
162
Drama
144
Biography
68
Adventure
46
Other values (9)
128
ValueCountFrequency (%) 
Action17524.2%
 
Comedy16222.4%
 
Drama14419.9%
 
Biography689.4%
 
Adventure466.4%
 
Crime446.1%
 
Animation425.8%
 
Horror334.6%
 
Mystery30.4%
 
Sci-Fi20.3%
 
Other values (4)40.6%
 

Length

Max length9
Median length6
Mean length6.398340249
Min length5

gross
Real number (ℝ≥0)

UNIQUE

Distinct count723
Unique (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean53309893.669432916
Minimum441
Maximum936662225
Zeros0
Zeros (%)0.0%
Memory size5.6 KiB

Quantile statistics

Minimum441
5-th percentile27778.5
Q12233985.5
median22525921
Q365184892.5
95-th percentile227843079.5
Maximum936662225
Range936661784
Interquartile range (IQR)62950907

Descriptive statistics

Standard deviation87040912.25
Coefficient of variation (CV)1.632734681
Kurtosis22.08329029
Mean53309893.67
Median Absolute Deviation (MAD)22105655
Skewness3.74713064
Sum3.854305312e+10
Variance7.576120405e+15
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
23392153410.1%
 
46116210.1%
 
2304957510.1%
 
3704710.1%
 
1674010.1%
 
4265200310.1%
 
4446960210.1%
 
13017841110.1%
 
3209510.1%
 
11640010.1%
 
Other values (713)71398.6%
 
ValueCountFrequency (%) 
44110.1%
 
213710.1%
 
225410.1%
 
410510.1%
 
426710.1%
 
ValueCountFrequency (%) 
93666222510.1%
 
65227062510.1%
 
53217732410.1%
 
48629556110.1%
 
45900586810.1%
 

name
Unsupported

REJECTED
UNSUPPORTED

Missing0
Missing (%)0.0%
Memory size5.8 KiB

rating
Categorical

Distinct count8
Unique (%)1.1%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
R
355
PG-13
267
PG
74
NOT RATED
 
17
UNRATED
 
5
Other values (3)
 
5
ValueCountFrequency (%) 
R35549.1%
 
PG-1326736.9%
 
PG7410.2%
 
NOT RATED172.4%
 
UNRATED50.7%
 
G30.4%
 
Not specified10.1%
 
NC-1710.1%
 

Length

Max length13
Median length2
Mean length2.831258645
Min length1

day_released
Real number (ℝ≥0)

Distinct count31
Unique (%)4.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean16.172890733056708
Minimum1
Maximum31
Zeros0
Zeros (%)0.0%
Memory size5.6 KiB

Quantile statistics

Minimum1
5-th percentile2
Q19
median17
Q323
95-th percentile29
Maximum31
Range30
Interquartile range (IQR)14

Descriptive statistics

Standard deviation8.365059624
Coefficient of variation (CV)0.5172272392
Kurtosis-1.127788383
Mean16.17289073
Median Absolute Deviation (MAD)7
Skewness-0.1388383412
Sum11693
Variance69.97422252
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
25486.6%
 
23324.4%
 
18314.3%
 
26304.1%
 
16294.0%
 
11283.9%
 
19283.9%
 
21273.7%
 
10263.6%
 
20263.6%
 
Other values (21)41857.8%
 
ValueCountFrequency (%) 
1243.3%
 
2172.4%
 
3162.2%
 
4212.9%
 
5192.6%
 
ValueCountFrequency (%) 
3191.2%
 
30121.7%
 
29182.5%
 
28162.2%
 
27253.5%
 

month_released
Real number (ℝ≥0)

Distinct count12
Unique (%)1.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.643153526970955
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Memory size5.6 KiB

Quantile statistics

Minimum1
5-th percentile1
Q14
median7
Q310
95-th percentile12
Maximum12
Range11
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.417798778
Coefficient of variation (CV)0.5144843883
Kurtosis-1.190246935
Mean6.643153527
Median Absolute Deviation (MAD)3
Skewness-0.1028426151
Sum4803
Variance11.68134849
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
87810.8%
 
10669.1%
 
4659.0%
 
11648.9%
 
9638.7%
 
7638.7%
 
1618.4%
 
12557.6%
 
3547.5%
 
5527.2%
 
Other values (2)10214.1%
 
ValueCountFrequency (%) 
1618.4%
 
2527.2%
 
3547.5%
 
4659.0%
 
5527.2%
 
ValueCountFrequency (%) 
12557.6%
 
11648.9%
 
10669.1%
 
9638.7%
 
87810.8%
 

year_released
Real number (ℝ≥0)

HIGH CORRELATION

Distinct count5
Unique (%)0.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2014.6929460580914
Minimum2013
Maximum2017
Zeros0
Zeros (%)0.0%
Memory size5.6 KiB

Quantile statistics

Minimum2013
5-th percentile2013
Q12014
median2015
Q32016
95-th percentile2017
Maximum2017
Range4
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.195463508
Coefficient of variation (CV)0.0005933725584
Kurtosis-1.04928311
Mean2014.692946
Median Absolute Deviation (MAD)1
Skewness0.07756779823
Sum1456623
Variance1.429132998
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
201518425.4%
 
201417824.6%
 
201617424.1%
 
201314820.5%
 
2017395.4%
 
ValueCountFrequency (%) 
201314820.5%
 
201417824.6%
 
201518425.4%
 
201617424.1%
 
2017395.4%
 
ValueCountFrequency (%) 
2017395.4%
 
201617424.1%
 
201518425.4%
 
201417824.6%
 
201314820.5%
 

released
Categorical

HIGH CARDINALITY

Distinct count308
Unique (%)42.6%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
2015-01-23
 
7
2016-11-18
 
7
2015-09-25
 
7
2016-03-4
 
6
2015-08-7
 
6
Other values (303)
690
ValueCountFrequency (%) 
2015-01-2371.0%
 
2016-11-1871.0%
 
2015-09-2571.0%
 
2016-03-460.8%
 
2015-08-760.8%
 
2016-08-2660.8%
 
2015-01-1660.8%
 
2014-08-860.8%
 
2016-10-2160.8%
 
2015-04-1060.8%
 
Other values (298)66091.3%
 

Length

Max length10
Median length10
Mean length9.742738589
Min length9

runtime
Real number (ℝ≥0)

Distinct count78
Unique (%)10.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean108.4508990318119
Minimum76
Maximum180
Zeros0
Zeros (%)0.0%
Memory size5.6 KiB

Quantile statistics

Minimum76
5-th percentile88
Q197
median106
Q3118
95-th percentile137
Maximum180
Range104
Interquartile range (IQR)21

Descriptive statistics

Standard deviation15.9554004
Coefficient of variation (CV)0.1471209602
Kurtosis1.573109862
Mean108.450899
Median Absolute Deviation (MAD)10
Skewness0.9896742011
Sum78410
Variance254.5748018
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
100314.3%
 
98263.6%
 
106253.5%
 
104212.9%
 
99202.8%
 
91202.8%
 
101202.8%
 
97202.8%
 
96202.8%
 
95192.6%
 
Other values (68)50169.3%
 
ValueCountFrequency (%) 
7620.3%
 
7710.1%
 
7920.3%
 
8010.1%
 
8120.3%
 
ValueCountFrequency (%) 
18020.3%
 
16910.1%
 
16710.1%
 
16520.3%
 
16310.1%
 

score
Real number (ℝ≥0)

Distinct count47
Unique (%)6.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.478423236514524
Minimum1.5
Maximum8.6
Zeros0
Zeros (%)0.0%
Memory size5.6 KiB

Quantile statistics

Minimum1.5
5-th percentile5.1
Q16
median6.5
Q37.1
95-th percentile7.8
Maximum8.6
Range7.1
Interquartile range (IQR)1.1

Descriptive statistics

Standard deviation0.8473221649
Coefficient of variation (CV)0.1307914185
Kurtosis1.751003128
Mean6.478423237
Median Absolute Deviation (MAD)0.5
Skewness-0.5803962431
Sum4683.9
Variance0.7179548511
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
6.3476.5%
 
6.5425.8%
 
6.7425.8%
 
6.2385.3%
 
7354.8%
 
6.6334.6%
 
6.4324.4%
 
5.7314.3%
 
7.1294.0%
 
6273.7%
 
Other values (37)36750.8%
 
ValueCountFrequency (%) 
1.510.1%
 
3.110.1%
 
3.510.1%
 
3.920.3%
 
4.120.3%
 
ValueCountFrequency (%) 
8.610.1%
 
8.510.1%
 
8.230.4%
 
8.191.2%
 
891.2%
 

star
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count437
Unique (%)60.4%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Robert De Niro
 
8
Miles Teller
 
6
Michael Fassbender
 
6
Jesse Eisenberg
 
6
Mark Wahlberg
 
6
Other values (432)
691
ValueCountFrequency (%) 
Robert De Niro81.1%
 
Miles Teller60.8%
 
Michael Fassbender60.8%
 
Jesse Eisenberg60.8%
 
Mark Wahlberg60.8%
 
Jason Bateman60.8%
 
Matthew McConaughey60.8%
 
Jennifer Lawrence50.7%
 
Christian Bale50.7%
 
Steve Carell50.7%
 
Other values (427)66491.8%
 

Length

Max length23
Median length13
Mean length13.19502075
Min length8

votes
Real number (ℝ≥0)

Distinct count722
Unique (%)99.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean104574.38865836791
Minimum980
Maximum1095553
Zeros0
Zeros (%)0.0%
Memory size5.6 KiB

Quantile statistics

Minimum980
5-th percentile6288.1
Q123162.5
median56365
Q3122419
95-th percentile388218.1
Maximum1095553
Range1094573
Interquartile range (IQR)99256.5

Descriptive statistics

Standard deviation134459.103
Coefficient of variation (CV)1.285774698
Kurtosis9.047139369
Mean104574.3887
Median Absolute Deviation (MAD)40249
Skewness2.628903852
Sum75607283
Variance1.807925039e+10
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
914120.3%
 
10547110.1%
 
3105710.1%
 
7202710.1%
 
853810.1%
 
34171510.1%
 
3354210.1%
 
1365410.1%
 
1365310.1%
 
5990610.1%
 
Other values (712)71298.5%
 
ValueCountFrequency (%) 
98010.1%
 
124810.1%
 
164510.1%
 
189610.1%
 
195910.1%
 
ValueCountFrequency (%) 
109555310.1%
 
89555210.1%
 
79134010.1%
 
68719210.1%
 
66862510.1%
 

writer
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count613
Unique (%)84.8%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Steven Knight
 
6
Woody Allen
 
4
Luc Besson
 
4
Skip Woods
 
3
Darren Lemke
 
3
Other values (608)
703
ValueCountFrequency (%) 
Steven Knight60.8%
 
Woody Allen40.6%
 
Luc Besson40.6%
 
Skip Woods30.4%
 
Darren Lemke30.4%
 
Scott Neustadter30.4%
 
Joel Coen30.4%
 
Peter Landesman30.4%
 
Christopher Markus30.4%
 
Andrew Jay Cohen30.4%
 
Other values (603)68895.2%
 

Length

Max length27
Median length13
Mean length13.02904564
Min length7

year
Categorical

HIGH CORRELATION

Distinct count4
Unique (%)0.6%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
2014
185
2013
185
2016
182
2015
171
ValueCountFrequency (%) 
201418525.6%
 
201318525.6%
 
201618225.2%
 
201517123.7%
 

Length

Max length4
Median length4
Mean length4
Min length4

hashtag
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count722
Unique (%)99.9%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
#Concussion
 
2
#Stoker
 
1
#TheBFG
 
1
#Don'tBreathe
 
1
#Dope
 
1
Other values (717)
717
ValueCountFrequency (%) 
#Concussion20.3%
 
#Stoker10.1%
 
#TheBFG10.1%
 
#Don'tBreathe10.1%
 
#Dope10.1%
 
#ALongWayDown10.1%
 
#Riddick10.1%
 
#ExMachina10.1%
 
#TheHollars10.1%
 
#300:RiseofanEmpire10.1%
 
Other values (712)71298.5%
 

Length

Max length51
Median length13
Mean length13.91286307
Min length3

name_roten
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count722
Unique (%)99.9%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
concussion
 
2
kubo_and_the_two_strings
 
1
mr._peabody_&_sherman
 
1
pawn_sacrifice
 
1
turbo
 
1
Other values (717)
717
ValueCountFrequency (%) 
concussion20.3%
 
kubo_and_the_two_strings10.1%
 
mr._peabody_&_sherman10.1%
 
pawn_sacrifice10.1%
 
turbo10.1%
 
as_above,_so_below10.1%
 
inherent_vice10.1%
 
the_east10.1%
 
need_for_speed10.1%
 
captain_america:_the_winter_soldier10.1%
 
Other values (712)71298.5%
 

Length

Max length59
Median length13
Mean length14.57952974
Min length2

calificacion1
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count98
Unique (%)14.7%
Missing58
Missing (%)8.0%
Infinite0
Infinite (%)0.0%
Mean57.83609022556391
Minimum0.0
Maximum100.0
Zeros4
Zeros (%)0.6%
Memory size5.6 KiB

Quantile statistics

Minimum0
5-th percentile12
Q134
median61
Q383
95-th percentile95
Maximum100
Range100
Interquartile range (IQR)49

Descriptive statistics

Standard deviation27.50222154
Coefficient of variation (CV)0.4755200677
Kurtosis-1.158299338
Mean57.83609023
Median Absolute Deviation (MAD)23
Skewness-0.2979229512
Sum38461
Variance756.3721895
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
91162.2%
 
92152.1%
 
84131.8%
 
72131.8%
 
47131.8%
 
18121.7%
 
89121.7%
 
54111.5%
 
81111.5%
 
95111.5%
 
Other values (88)53874.4%
 
(Missing)588.0%
 
ValueCountFrequency (%) 
040.6%
 
310.1%
 
430.4%
 
520.3%
 
760.8%
 
ValueCountFrequency (%) 
10020.3%
 
9930.4%
 
9850.7%
 
9791.2%
 
9671.0%
 

calificacion2
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count77
Unique (%)11.6%
Missing58
Missing (%)8.0%
Infinite0
Infinite (%)0.0%
Mean59.19849624060151
Minimum15.0
Maximum94.0
Zeros0
Zeros (%)0.0%
Memory size5.6 KiB

Quantile statistics

Minimum15
5-th percentile30
Q145
median59
Q374
95-th percentile88
Maximum94
Range79
Interquartile range (IQR)29

Descriptive statistics

Standard deviation18.05938157
Coefficient of variation (CV)0.3050648702
Kurtosis-0.9046208248
Mean59.19849624
Median Absolute Deviation (MAD)14
Skewness-0.03989315974
Sum39367
Variance326.1412628
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
49192.6%
 
51172.4%
 
71152.1%
 
44152.1%
 
57152.1%
 
40152.1%
 
38152.1%
 
76152.1%
 
52141.9%
 
41141.9%
 
Other values (67)51170.7%
 
(Missing)588.0%
 
ValueCountFrequency (%) 
1510.1%
 
1710.1%
 
1910.1%
 
2010.1%
 
2220.3%
 
ValueCountFrequency (%) 
9420.3%
 
9330.4%
 
9240.6%
 
9191.2%
 
9040.6%
 

synopsis
Categorical

HIGH CARDINALITY

Distinct count661
Unique (%)92.1%
Missing5
Missing (%)0.7%
Memory size5.6 KiB
Sin Datos
 
56
a fateful blow to the head makes a middle aged lesbian housewife robin weigert seek satisfaction as a high end escort
 
2
a drug addled manipulative misanthrope james mcavoy begins to experience increasingly severe hallucinations as he tries to solve the murder of a japanese student
 
2
hoping to harness the magical smurf essence evil wizard gargamel creates a pair of smurflike creatures called naughties however only a real smurf can give gargamel what he wants so he kidnaps smurfette to force her to cast a spell that will transform the naughties into smurfs papa clumsy and the rest of the smurfs reunite with their human friends patrick neil patrick harris and grace jayma mays to rescue smurfette from the wizard s clutches
 
1
looking for an exciting career young bobby dorfman leaves new york for the glitz and glamour of 1930s hollywood after landing a job with his uncle bobby falls for vonnie a charming woman who happens to be his employer s mistress settling for friendship but ultimately heartbroken bobby returns to the bronx and begins working in a nightclub everything falls into place when he finds romance with a beautiful socialite until vonnie walks back into his life and captures his heart once again
 
1
Other values (656)
656
ValueCountFrequency (%) 
Sin Datos567.7%
 
a fateful blow to the head makes a middle aged lesbian housewife robin weigert seek satisfaction as a high end escort20.3%
 
a drug addled manipulative misanthrope james mcavoy begins to experience increasingly severe hallucinations as he tries to solve the murder of a japanese student20.3%
 
hoping to harness the magical smurf essence evil wizard gargamel creates a pair of smurflike creatures called naughties however only a real smurf can give gargamel what he wants so he kidnaps smurfette to force her to cast a spell that will transform the naughties into smurfs papa clumsy and the rest of the smurfs reunite with their human friends patrick neil patrick harris and grace jayma mays to rescue smurfette from the wizard s clutches10.1%
 
looking for an exciting career young bobby dorfman leaves new york for the glitz and glamour of 1930s hollywood after landing a job with his uncle bobby falls for vonnie a charming woman who happens to be his employer s mistress settling for friendship but ultimately heartbroken bobby returns to the bronx and begins working in a nightclub everything falls into place when he finds romance with a beautiful socialite until vonnie walks back into his life and captures his heart once again10.1%
 
anna is a bereft young german woman whose fiance frantz was killed in the trenches of world war i adrien a french veteran of the war makes a mysterious appearance in her town placing flowers on frantz s grave adrien s presence is met with resistance by the small community still reeling from germany s defeat yet anna gradually becomes closer to the handsome and melancholy young man as she learns of his deep friendship with frantz10.1%
 
mild mannered sheep farmer albert stark seth macfarlane feels certain that the western frontier is trying to kill him then he loses his girlfriend louise amanda seyfried to the town s most successful businessman however a beautiful pistol packing woman named anna charlize theron rides into town and helps albert find his inner courage then stark must put his newfound bravery to the test when anna s outlaw husband arrives with plans to plant him in an unmarked grave10.1%
 
in rural england 1865 a woman who is trapped in a loveless marriage to a much older man begins a passionate affair with a man her own age10.1%
 
in the years before the civil war solomon northup chiwetel ejiofor a free black man from upstate new york is kidnapped and sold into slavery in the south subjected to the cruelty of one malevolent owner michael fassbender he also finds unexpected kindness from another as he struggles continually to survive and maintain some of his dignity then in the 12th year of the disheartening ordeal a chance meeting with an abolitionist from canada changes solomon s life forever10.1%
 
when astronauts blast off from the planet mars they leave behind mark watney matt damon presumed dead after a fierce storm with only a meager amount of supplies the stranded visitor must utilize his wits and spirit to find a way to survive on the hostile planet meanwhile back on earth members of nasa and a team of international scientists work tirelessly to bring him home while his crew mates hatch their own plan for a daring rescue mission10.1%
 
Other values (651)65190.0%
 
(Missing)50.7%
 

Length

Max length499
Median length466
Mean length354.2655602
Min length3

ruta
URL

Distinct count721
Unique (%)99.7%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
https://www.rottentomatoes.com/m/concussion
 
2
https://www.rottentomatoes.com/m/filth_2013
 
2
https://www.rottentomatoes.com/m/kill_the_messenger_2015
 
1
https://www.rottentomatoes.com/m/eye_in_the_sky
 
1
https://www.rottentomatoes.com/m/big_hero_6
 
1
Other values (716)
716
ValueCountFrequency (%) 
https://www.rottentomatoes.com/m/concussion20.3%
 
https://www.rottentomatoes.com/m/filth_201320.3%
 
https://www.rottentomatoes.com/m/kill_the_messenger_201510.1%
 
https://www.rottentomatoes.com/m/eye_in_the_sky10.1%
 
https://www.rottentomatoes.com/m/big_hero_610.1%
 
https://www.rottentomatoes.com/m/nocturnal_animals10.1%
 
https://www.rottentomatoes.com/m/nebraska10.1%
 
https://www.rottentomatoes.com/m/x_men_apocalypse10.1%
 
https://www.rottentomatoes.com/m/irrational_man10.1%
 
https://www.rottentomatoes.com/m/august_osage_county10.1%
 
Other values (711)71198.3%
 
ValueCountFrequency (%) 
https723100.0%
 
ValueCountFrequency (%) 
www.rottentomatoes.com723100.0%
 
ValueCountFrequency (%) 
/m/concussion20.3%
 
/m/filth_201320.3%
 
/m/philomena10.1%
 
/m/gangster_squad_201210.1%
 
/m/carol10.1%
 
/m/life_after_beth10.1%
 
/m/transcendence_201410.1%
 
/m/i_spit_on_your_grave_210.1%
 
/m/selma10.1%
 
/m/contracted10.1%
 
Other values (711)71198.3%
 
ValueCountFrequency (%) 
723100.0%
 
ValueCountFrequency (%) 
723100.0%
 

promedio_ganancia
Real number (ℝ≥0)

ZEROS

Distinct count53
Unique (%)7.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.589211618257263
Minimum0
Maximum2672
Zeros292
Zeros (%)40.4%
Memory size5.6 KiB

Quantile statistics

Minimum0
5-th percentile0
Q10
median1
Q32
95-th percentile22.6
Maximum2672
Range2672
Interquartile range (IQR)2

Descriptive statistics

Standard deviation135.6247624
Coefficient of variation (CV)7.295885655
Kurtosis225.1033012
Mean18.58921162
Median Absolute Deviation (MAD)1
Skewness13.43063868
Sum13440
Variance18394.07617
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
029240.4%
 
122330.8%
 
27410.2%
 
3233.2%
 
4192.6%
 
5141.9%
 
781.1%
 
671.0%
 
850.7%
 
950.7%
 
Other values (43)537.3%
 
ValueCountFrequency (%) 
029240.4%
 
122330.8%
 
27410.2%
 
3233.2%
 
4192.6%
 
ValueCountFrequency (%) 
267210.1%
 
125210.1%
 
124510.1%
 
89810.1%
 
61810.1%
 

calificacion1_dec
Real number (ℝ≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct count6
Unique (%)0.9%
Missing58
Missing (%)8.0%
Infinite0
Infinite (%)0.0%
Mean2.9037593984962404
Minimum0.0
Maximum5.0
Zeros26
Zeros (%)3.6%
Memory size5.6 KiB

Quantile statistics

Minimum0
5-th percentile1
Q12
median3
Q34
95-th percentile5
Maximum5
Range5
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.422623045
Coefficient of variation (CV)0.4899245597
Kurtosis-1.027528024
Mean2.903759398
Median Absolute Deviation (MAD)1
Skewness-0.2483756321
Sum1931
Variance2.023856328
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
419627.1%
 
212417.2%
 
312016.6%
 
111415.8%
 
58511.8%
 
0263.6%
 
(Missing)588.0%
 
ValueCountFrequency (%) 
0263.6%
 
111415.8%
 
212417.2%
 
312016.6%
 
419627.1%
 
ValueCountFrequency (%) 
58511.8%
 
419627.1%
 
312016.6%
 
212417.2%
 
111415.8%
 

calificacion2_dec
Real number (ℝ≥0)

HIGH CORRELATION
MISSING

Distinct count5
Unique (%)0.8%
Missing58
Missing (%)8.0%
Infinite0
Infinite (%)0.0%
Mean2.954887218045113
Minimum1.0
Maximum5.0
Zeros0
Zeros (%)0.0%
Memory size5.6 KiB

Quantile statistics

Minimum1
5-th percentile2
Q12
median3
Q34
95-th percentile4
Maximum5
Range4
Interquartile range (IQR)2

Descriptive statistics

Standard deviation0.9399489032
Coefficient of variation (CV)0.318099756
Kurtosis-0.7480501217
Mean2.954887218
Median Absolute Deviation (MAD)1
Skewness-0.05191936713
Sum1965
Variance0.8835039406
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%) 
322431.0%
 
219827.4%
 
419426.8%
 
1314.3%
 
5182.5%
 
(Missing)588.0%
 
ValueCountFrequency (%) 
1314.3%
 
219827.4%
 
322431.0%
 
419426.8%
 
5182.5%
 
ValueCountFrequency (%) 
5182.5%
 
419426.8%
 
322431.0%
 
219827.4%
 
1314.3%
 

Interactions

Correlations

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Missing values

Sample

First rows

budgetcompanycountrydirectorgenregrossnameratingday_releasedmonth_releasedyear_releasedreleasedruntimescorestarvoteswriteryearhashtagname_rotencalificacion1calificacion2synopsisrutapromedio_gananciacalificacion1_deccalificacion2_dec
0100000000Red Granite PicturesUSAMartin ScorseseBiography116900694The Wolf of Wall StreetR251220132013-12-251808.2Leonardo DiCaprio895552Terence Winter2013#TheWolfofWallStreetthe_wolf_of_wall_street80.083.0in 1987 jordan belfort leonardo dicaprio takes an entry level job at a wall street brokerage firm by the early 1990s while still in his 20s belfort founds his own firm stratton oakmont together with his trusted lieutenant jonah hill and a merry band of brokers belfort makes a huge fortune by defrauding wealthy investors out of millions however while belfort and his cronies partake in a hedonistic brew of sex drugs and thrills the sec and the fbi close in on his empire of excesshttps://www.rottentomatoes.com/m/the_wolf_of_wall_street_201314.04.0
120000000New Line CinemaUSAJames WanHorror137400141The ConjuringR19720132013-07-191127.5Patrick Wilson342870Chad Hayes2013#TheConjuringthe_conjuring86.083.0in 1970 paranormal investigators and demonologists lorraine vera farmiga and ed patrick wilson warren are summoned to the home of carolyn lili taylor and roger ron livingston perron the perrons and their five daughters have recently moved into a secluded farmhouse where a supernatural presence has made itself known though the manifestations are relatively benign at first events soon escalate in horrifying fashion especially after the warrens discover the house s macabre historyhttps://www.rottentomatoes.com/m/the_conjuring04.04.0
246000000Alcon EntertainmentUSADenis VilleneuveCrime61002302PrisonersR20920132013-09-201538.1Hugh Jackman449489Aaron Guzikowski2013#Prisonersprisoners81.087.0keller dover hugh jackman faces a parent s worst nightmare when his 6 year old daughter anna and her friend go missing the only lead is an old motorhome that had been parked on their street the head of the investigation detective loki jake gyllenhaal arrests the driver paul dano but a lack of evidence forces loki to release his only suspect dover knowing that his daughter s life is at stake decides that he has no choice but to take matters into his own handshttps://www.rottentomatoes.com/m/prisoners_201314.04.0
3150000000Walt Disney Animation StudiosUSAChris BuckAnimation400738009FrozenPG271120132013-11-271027.5Kristen Bell464149Jennifer Lee2013#Frozenfrozen56.057.0a performance artist turns his suicide into a work of art by melting ice with his bodyhttps://www.rottentomatoes.com/m/frozen03.03.0
475000000Summit EntertainmentUSALouis LeterrierCrime117723989Now You See MePG-1331520132013-05-311157.3Jesse Eisenberg505432Ed Solomon2013#NowYouSeeMenow_you_see_me51.070.0charismatic magician atlas jesse eisenberg leads a team of talented illusionists called the four horsemen atlas and his comrades mesmerize audiences with a pair of amazing magic shows that drain the bank accounts of the corrupt and funnel the money to audience members a federal agent mark ruffalo and an interpol detective m lanie laurent intend to rein in the horsemen before their next caper and they turn to thaddeus morgan freeman a famous debunker for helphttps://www.rottentomatoes.com/m/now_you_see_me13.04.0
523000000Annapurna PicturesUSASpike JonzeDrama25568251HerR10120142014-01-101268.0Joaquin Phoenix404796Spike Jonze2013#Herher95.082.0a sensitive and soulful man earns a living by writing personal letters for other people left heartbroken after his marriage ends theodore joaquin phoenix becomes fascinated with a new operating system which reportedly develops into an intuitive and unique entity in its own right he starts the program and meets samantha scarlett johansson whose bright voice reveals a sensitive playful personality though friends initially the relationship soon deepens into lovehttps://www.rottentomatoes.com/m/her15.04.0
6225000000Warner Bros.USAZack SnyderAction291045518Man of SteelPG-1314620132013-06-141437.1Henry Cavill590734David S. Goyer2013#ManofSteelman_of_steel56.075.0with the imminent destruction of krypton their home planet jor el russell crowe and his wife seek to preserve their race by sending their infant son to earth the child s spacecraft lands at the farm of jonathan kevin costner and martha diane lane kent who name him clark and raise him as their own son though his extraordinary abilities have led to the adult clark henry cavill living on the fringe of society he finds he must become a hero to save those he loves from a dire threathttps://www.rottentomatoes.com/m/superman_man_of_steel13.04.0
737000000New Line CinemaUSARawson Marshall ThurberComedy150394119We're the MillersR7820132013-08-71107.0Jason Sudeikis342500Bob Fisher2013#We'retheMillerswe're_the_millers48.072.0small time pot dealer david jason sudeikis learns the hard way that no good deed goes unpunished trying to help some teens he is jumped by thugs and loses his cash and stash now david s in big debt to his supplier and to wipe the slate clean he must go to mexico to pick up the guy s latest shipment to accomplish his mission dave devises a foolproof plan he packs a fake family into a huge rv and heads south of the border for a wild weekend that is sure to end with a banghttps://www.rottentomatoes.com/m/were_the_millers02.04.0
80Quat'sous FilmsFranceAbdellatif KechicheDrama2199675Blue Is the Warmest ColorNC-1714220142014-02-141807.8Léa Seydoux107119Abdellatif Kechiche2013#BlueIstheWarmestColorblue_is_the_warmest_color89.085.0a french teen ad le exarchopoulos forms a deep emotional and sexual connection with an older art student l a seydoux she met in a lesbian barhttps://www.rottentomatoes.com/m/blue_is_the_warmest_color04.04.0
9190000000Warner Bros.USAGuillermo del ToroAction101802906Pacific RimPG-1312720132013-07-121317.0Idris Elba407588Travis Beacham2013#PacificRimpacific_rim72.077.0long ago legions of monstrous creatures called kaiju arose from the sea bringing with them all consuming war to fight the kaiju mankind developed giant robots called jaegers designed to be piloted by two humans locked together in a neural bridge however even the jaegers are not enough to defeat the kaiju and humanity is on the verge of defeat mankind s last hope now lies with a washed up ex pilot charlie hunnam an untested trainee rinko kikuchi and an old obsolete jaegerhttps://www.rottentomatoes.com/m/pacific_rim_201324.04.0

Last rows

budgetcompanycountrydirectorgenregrossnameratingday_releasedmonth_releasedyear_releasedreleasedruntimescorestarvoteswriteryearhashtagname_rotencalificacion1calificacion2synopsisrutapromedio_gananciacalificacion1_deccalificacion2_dec
7130StudioCanalUKSusanna WhiteCrime3152725Our Kind of TraitorR30920162016-09-301086.2Carlos Acosta13857John le Carré2016#OurKindofTraitorour_kind_of_traitor72.050.0a money launderer stellan skarsgard for russian gangsters asks a couple vacationing in marrakech morocco to deliver incriminating evidence to an mi6 agent damian lewishttps://www.rottentomatoes.com/m/our_kind_of_traitor04.02.0
7148500000CBS FilmsUSASteve CarrAnimation19985196Middle School: The Worst Years of My LifePG71020162016-10-7926.1Griffin Gluck4556Chris Bowman2016#MiddleSchool:TheWorstYearsofMyLifemiddle_school:_the_worst_years_of_my_life63.058.0rafe khatchadorian griffin gluck has an epic imagination and a slight problem with authority and these things collide when he transfers to a middle school where students are expected to follow the rules this doesn t sit well with rafe with help from his new friend leo thomas barbusca the mischievous lad concocts schemes to drive his tyrannical principal andy daly crazy while also using his charm and wits to impress a girl isabela moner and battle the bullieshttps://www.rottentomatoes.com/m/middle_school_the_worst_years_of_my_life03.03.0
7150Killer FilmsUSAAndrew NeelDrama23020GoatR23920162016-09-23965.7Ben Schnetzer4439David Gordon Green2016#Goatgoat79.044.0nineteen year old brad is a new college student and wants desperately to fit in taking a cue from his older brother brett brad decides to pledge a fraternity at first it s all parties and girls but as brad enters into the final stretch of the pledging ritual known as hell week things take a violent humiliating turn what occurs in the name of brotherhood tests both boys and their relationship in brutal wayshttps://www.rottentomatoes.com/m/goat_201604.02.0
7160Anna Biller ProductionsUSAAnna BillerComedy228894The Love WitchUNRATED10320172017-03-101206.2Samantha Robinson6054Anna Biller2016#TheLoveWitchthe_love_witch95.061.0elaine samantha robinson a beautiful young witch is determined to find a man to love her in her gothic victorian apartment she makes spells and potions then picks up men and seduces them however her spells work too well and she ends up with a string of hapless victims when she at last meets the man of her dreams her desperation to be loved drives her to the brink of insanity and murderhttps://www.rottentomatoes.com/m/the_love_witch05.03.0
71720000000LD EntertainmentUSAKevin ReynoldsAction36874745RisenPG-1319220162016-02-191076.3Joseph Fiennes19084Kevin Reynolds2016#Risenrisen53.070.0roman military tribune clavius joseph fiennes remains set in his ways after serving 25 years in the army he arrives at a crossroad when he s tasked to investigate the mystery of what happened to jesus cliff curtis following the crucifixion accompanied by trusted aide lucius tom felton his quest to disprove rumors of a risen messiah makes him question his own beliefs and spirituality as his journey takes him to places never dreamed of clavius discovers the truth that he s been seekinghttps://www.rottentomatoes.com/m/risen_201613.04.0
7180Fox Searchlight PicturesUKMandie FletcherComedy4750497Absolutely Fabulous: The MovieR22720162016-07-22915.4Jennifer Saunders9161Jennifer Saunders2016#AbsolutelyFabulous:TheMovieabsolutely_fabulous:_the_movie59.041.0publicist edina monsoon and best friend patsy stone are still shopping drinking and clubbing their way around london s trendiest hot spots while attending an elite party they wind up knocking supermodel kate moss into the river thames her untimely demise creates a media firestorm leading the paparazzi to relentlessly pursue the hapless duo seeking refuge the gals flee to the french riviera where they hatch a plan to make their escape permanent and live the high life foreverhttps://www.rottentomatoes.com/m/absolutely_fabulous_the_movie03.02.0
7190Siempre Viva ProductionsUSAPaul DuddridgeDrama28368Mothers and DaughtersPG-136520162016-05-6904.9Selma Blair1959Paige Cameron2016#MothersandDaughtersmothers_and_daughters18.028.0a pregnant photographer selma blair captures motherhood on film while re examining her relationship with her estranged momhttps://www.rottentomatoes.com/m/mothers_and_daughters_201601.01.0
7203500000Warner Bros. AnimationUSASam LiuAnimation3775000Batman: The Killing JokeR25720162016-07-25766.5Kevin Conroy36333Brian Azzarello2016#Batman:TheKillingJokebatman:_the_killing_joke40.046.0batman kevin conroy must save commissioner gordon ray wise from the joker s mark hamill twisted quest to drive him insanehttps://www.rottentomatoes.com/m/batman_the_killing_joke12.02.0
7210Borderline PresentsUSANicolas PesceDrama25981The Eyes of My MotherR21220162016-12-2766.2Kika Magalhães6947Nicolas Pesce2016#TheEyesofMyMotherthe_eyes_of_my_mother78.057.0francisca kika magalhaes has been unfazed by death from an early age because her mother formerly a surgeon in portugal imbued her with a thorough understanding of the human anatomy when tragedy shatters her family s idyllic life in the countryside her deep trauma gradually awakens some unique curiosities as she grows up her desire to connect with the world around her takes a distinctly dark formhttps://www.rottentomatoes.com/m/the_eyes_of_my_mother04.03.0
7220Les Productions du TrésorFranceNicole GarciaDrama37757From the Land of the MoonR28720172017-07-281206.7Marion Cotillard2411Milena Agus2016#FromtheLandoftheMoonfrom_the_land_of_the_moon32.065.0after world war ii a free spirited woman marion cotillard in a loveless marriage falls in love with another manhttps://www.rottentomatoes.com/m/from_the_land_of_the_moon02.03.0